/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package com.imptec.reportfly.Util;

import com.imptec.reportfly.report.*;

/**
 *
 * @author admin
 */
public class Formateador {


    public static String formatDateForSQL(String date) {
	String result = null;
        String month = null;
        System.out.println("uo"+String.valueOf(date.substring(3,5)));    
        switch(Integer.parseInt(date.substring(3,5))) {
		case 1:
					month="Jan";
					break;
                case 2:
					month="Feb";
					break;
                case 3:
					month="Mar";
					break;
                case 4:
					month="Apr";
					break;
                case 5:
					month="May";
					break;
                case 6:
					month="Jun";
					break;
                case 7:
					month="Jul";
					break;
                case 8:
					month="Aug";
					break;
                case 9:
					month="Sep";
					break;
                case 10:
					month="Oct";
					break;
                case 11:
					month="Nov";
					break;
                case 12:
					month="Dec";
					break;

        }
        result = date.substring(0,2)+"-"+month+"-"+date.substring(6,10);
        System.out.println(result);
        return result;
	}


}
